TermGallery
English
English
Spanish
Catalan
Portuguese
Russian
EN
English
Español
Català
Português
Русский
Russian
журнализация транзакций
Spanish
log
History of actions executed by a database management system.
database log
transaction journal
binary log
audit trail
logging and recovery
Russian
журнализация транзакций
database log
transaction journal
binary log
audit trail
logging and recovery
1
To protect against media failure, keep the
database
logs
on a different physical device from the database itself.
1
This is the
binary
log
position you can use for point-in-time recovery.
2
In the next chapter, we examine the
binary
log
in greater detail.
3
It applies only to the
binary
log
,
not to the relay log.
4
As the event is written to the
binary
log
on the master
5
Clearly, there is much to the
binary
log
-
including
its
use, composition, and techniques.
1
The consolidated
audit
trail
has yet to be finalized by the commission.
2
Police believe they have identified the executive responsibleby following an electronic
audit
trail
.
3
Streams of Chatter activity are attached to each case, providing an
audit
trail
.
4
Include capacity for the system
audit
trail
in the space calculation.
5
These provide instantaneous transfer of funds and no
audit
trail
.
1
Truncating your
transaction
log
is therefore not acceptable for most production systems.
2
Of course, you must be careful where you back up your
transaction
log
.
3
The long-term solution is to move the
transaction
log
to a new disk.
4
Each storage engine has its own
transaction
log
for this purpose.
5
The after image of the page is recorded in the
transaction
log
buffer.
6
You also need to ensure that InnoDB's
transaction
log
files match its tablespace files.
7
The after image of the page is now flushed to the physical
transaction
log
.
8
The
transaction
log
is the record of all the changes made to a database.
9
In its simplest form, a
transaction
log
backup like this:
10
If the
transaction
log
does fill up, there are several options to truncate it:
11
I wake my computer and call up the
transaction
log
.
12
However, because you are truncating your
transaction
log
,
changes made on multiple days are unavailable.
13
Moving the
transaction
log
to a dedicated disk can reduce-althoughnot
eliminate
-
the
transaction
log
overhead.
14
After this completes, apply each
transaction
log
starting with the oldest and finishing with the newest.
15
A given page may be changed several times; replaying the
transaction
log
also changes it several times.
16
Recording the change in the
transaction
log
buffer before actually making the change is a safety measure.
Russian
журнализация транзакций
Spanish
log